Time Output Registry entry
Specify the format in which times will display in a client when retrieved from a database.
Usage
This Registry entry can be assigned to users, groups and system-wide:
| Key | User | Group | Key | System |
|---|---|---|---|---|
| Key 1 | User
|
Group
|
Key 1 | System
|
| Key 2 | user | group | Key 2 | Setting
|
| Key 3 | Setting
|
Key 3 | Format
|
|
| Key 4 | Format
|
Key 4 | Time Output
|
|
| Key 5 | Time Output
|
|||
| Value | format | Value | format | |
User
|
user | Setting
|
Format
|
Time Output
|
format |
Group
|
group | Setting
|
Format
|
Time Output
|
format |
System
|
Setting
|
Format
|
Time Output
|
format |
where:
| format | is a series of special characters: | |
|
Character |
Description |
|
HH
|
Hour - two digit 24 hour format with values ranging from 00 - 23 |
|
H
|
Hour - 24 hour format with values ranging from 0 - 23 |
|
hh
|
Hour - two digit 12 hour format with values ranging from 01 - 12 |
|
h
|
Hour - 12 hour format with values ranging from 1 - 12 |
|
m
|
Minute - values ranging from 0 - 59 |
|
mm
|
Minute - two digit values ranging from 00 - 59 |
|
M
|
Minute - displayed with a decimal component that represents the seconds as a fraction of a minute, e.g. 4 minutes, 15 seconds, displays as 4.25 |
|
MM
|
Minute - as for M, except that the minutes component is a two digit value, eg. 04.25 |
|
s
|
Second - values ranging from 0 - 59 |
|
ss
|
Second - two digit values ranging from 00 - 59 |
|
t
|
Displays am or pm as appropriate. |
|
Note: The format characters can be combined to create the desired date string, separated by any other character(s).
Examples
This setting will generate a time format of 18:43:
| Field | Setting |
|---|---|
| Key 1 | System
|
| Key 2 | Setting
|
| Key 3 | Format
|
| Key 4 | Time Output
|
| Value | HH:mm
|
This setting will generate a time format of 6:43pm:
| Field | Setting |
|---|---|
| Key 1 | System
|
| Key 2 | Setting
|
| Key 3 | Format
|
| Key 4 | Time Output
|
| Value | h:mmt
|